UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'D6YC8COnA7DVHYjBsROlhe4EXGFIZ5NA1A1IWV/O2Kk='
WHERE
key_id = 'a2bac3d93521b53fc0400a32cc52a136e05b8de194f47e50fc7d23f979cb1513'
AND (
token = 'D6YC8COnA7DVHYjBsROlhe4EXGFIZ5NA1A1IWV/O2Kk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)