UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'uB6MXHl1NRwwlFjacTSVvvneaDlYF2yPD6yCheTeHIE='
WHERE
key_id = '1e0288957f137590afe2d2f884b8a540a2d3dc189864ac7050e6f65a027579bc'
AND (
token = 'uB6MXHl1NRwwlFjacTSVvvneaDlYF2yPD6yCheTeHIE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)