UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'xX5jef1wFNNp8RXBTXekbPoArTqmFfBEIa0YygvMiw4='
WHERE
key_id = '3b4d735eb76e580e7903d7b083a09fac3775caf45c76b656bad89ce70efd6254'
AND (
token = 'xX5jef1wFNNp8RXBTXekbPoArTqmFfBEIa0YygvMiw4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)