UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'RE647VdkSsZPwhJJFctFFSUjd+O9I3tNdiZj884wXhY='
WHERE
key_id = '4bfc41fed9e0af2b3fad7426b80f3433ef2a9e254a15d67701f3395cf62051d6'
AND (
token = 'RE647VdkSsZPwhJJFctFFSUjd+O9I3tNdiZj884wXhY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)