UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9VHht38nW8GsY5eHtOFlzEC1lEfSPA9/v0VCveuAaAk='
WHERE
key_id = 'a05636849a79cebc479d87b356abaccb68e88c1d5a82c1048c1a79e8eadb08c8'
AND (
token = '9VHht38nW8GsY5eHtOFlzEC1lEfSPA9/v0VCveuAaAk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)