UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZiaU8XfXMqOz/KIVzWDqpqoakOJ+/FFGNX05FrUiieE='
WHERE
key_id = '72339df5aaad26df40953651196d8d9a594f62eb2d083a5bf3214c5c60218b3a'
AND (
token = 'ZiaU8XfXMqOz/KIVzWDqpqoakOJ+/FFGNX05FrUiieE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)