UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'odpst8EH3VvoAdPPCWIxtQrm0DY4o2TiYCxNQHcWSgA='
WHERE
key_id = '0c22bb2fe885a0fc605e9c6ae70dd47e8975e6cb24441ed7c79835524ef232bc'
AND (
token = 'odpst8EH3VvoAdPPCWIxtQrm0DY4o2TiYCxNQHcWSgA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)