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