UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '07+vF1XIw+dvgVMOB71eDnqmT0mxqYSVVsnnia4heFA='
WHERE
key_id = '8e9e8ec7733bbb072440f7be8c04731b6d5608114f21195fe595bae2280fc111'
AND (
token = '07+vF1XIw+dvgVMOB71eDnqmT0mxqYSVVsnnia4heFA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)