UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'X/eiWboOz9BXYAzwjXavx+wS1G7M1lmpavabrN5mtFs='
WHERE
key_id = '8facf28a448407a3291f90fa915c151de37e93317dd03a660271e04c05dc2275'
AND (
token = 'X/eiWboOz9BXYAzwjXavx+wS1G7M1lmpavabrN5mtFs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)