UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'qrNtHXIaawMEydzyAUWC61nzlZWHYfk8j1LMWctjKpM='
WHERE
key_id = '0942602e492006f4fa7f0ee0b5a182f60c74b9fb7ed711dbd4508cf4d9235ed0'
AND (
token = 'qrNtHXIaawMEydzyAUWC61nzlZWHYfk8j1LMWctjKpM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)