UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'S20hTyaUcJWyFtLnriKQZ2NCvRMRWYkp2bz8fEA0cy8='
WHERE
key_id = 'def8668d9ab58f0a342635932687dfa56eb662733ff9ad4cbb8678d3820f8330'
AND (
token = 'S20hTyaUcJWyFtLnriKQZ2NCvRMRWYkp2bz8fEA0cy8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)