UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'hI1tgrvEro6P9mNm5glyfnzGM2qIGBlmmMW1aJqn+wI='
WHERE
key_id = 'ec4c77a88765ba25c77fb49b716edd42032ac4a4b13548772f6c9ac03a4d058b'
AND (
token = 'hI1tgrvEro6P9mNm5glyfnzGM2qIGBlmmMW1aJqn+wI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)