UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'CR7hUu0bBi29eYl1IWDlfA+oexrS5cDNvtC+Pt+6/XM='
WHERE
key_id = '20ce0bba492237703d6de97add6ba3de3147bb548b1acc4a328bf271a27288be'
AND (
token = 'CR7hUu0bBi29eYl1IWDlfA+oexrS5cDNvtC+Pt+6/XM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)