UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'QGVVFBZPUCCzPp56uXZKvd/JiKmFWkWpD0pYhmRr9xg='
WHERE
key_id = 'd2d1aa5e27aa770f1b9bdbc0186308140302ea3b122f91b800c38abd7b4456de'
AND (
token = 'QGVVFBZPUCCzPp56uXZKvd/JiKmFWkWpD0pYhmRr9xg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)