UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'gnerGvbhV7ydZCUY2r1TaJ6YwyDDDO/OEbRbwFMbIvA='
WHERE
key_id = '16f8ac848591338aaefd846362c8a7be6482c280a3cdbabc636e4d2a28806367'
AND (
token = 'gnerGvbhV7ydZCUY2r1TaJ6YwyDDDO/OEbRbwFMbIvA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)