UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'CvJ4J6uiMoV/+DFnv9Lp9yAoBdXOvRryPZ9sOKi2Xqg='
WHERE
key_id = 'cd1f9b97e8d3fe94d7b1cf58539d8bfd29e6fcc97c1f08d093ce22831ae1e5fb'
AND (
token = 'CvJ4J6uiMoV/+DFnv9Lp9yAoBdXOvRryPZ9sOKi2Xqg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)