UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'rgU1ci5sKTi9Ja7yO9joyv2UehM5z/BfHZPyG5teyxE='
WHERE
key_id = '1c76e7757932699a756985687176b7907f780479e0b5edf76c1a3bddf91a8169'
AND (
token = 'rgU1ci5sKTi9Ja7yO9joyv2UehM5z/BfHZPyG5teyxE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)