UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'LPAVa/0qcLNSTHf96PuhNjje6Yn04+EAFGG1PwRYVn4='
WHERE
key_id = '8968b5fd6436c770b843b44b69917e2680ce9a1f28c4f0c63db1efd6a963f365'
AND (
token = 'LPAVa/0qcLNSTHf96PuhNjje6Yn04+EAFGG1PwRYVn4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)