UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8zG3UgNE4XIm8XSpPFvX9G0hKnsJu3T9iokmEHTqSDA='
WHERE
key_id = 'c6fc76c9238065cc211f65291d9cfd4babc0f817fb10d79aca482716dc829ab3'
AND (
token = '8zG3UgNE4XIm8XSpPFvX9G0hKnsJu3T9iokmEHTqSDA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)