UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'dDWv33kDQEHgZWpCOcgqLM6EDwplSBNCYMdqMe5M+qM='
WHERE
key_id = 'e461768ba8e03ea979146960b61ae9ca02decdb5300dc73af49d3fb28d15ff90'
AND (
token = 'dDWv33kDQEHgZWpCOcgqLM6EDwplSBNCYMdqMe5M+qM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)