UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'tsWn2weBlddicrydeAczfx+7cuHHafrO7Ttcg09WcmM='
WHERE
key_id = '30c445a6640a935e1d593f96bcdae481b79c12e38aaa9927cd5428e06b0fe20c'
AND (
token = 'tsWn2weBlddicrydeAczfx+7cuHHafrO7Ttcg09WcmM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)