UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XdCiU3+cRxODpS5zDdyLZAwRq2DhTo3Mbwz8iraB3Zc='
WHERE
key_id = '311840ce82259e4ab180a82bb4d2aebbee39c043f01536afcbbf96897a1c5815'
AND (
token = 'XdCiU3+cRxODpS5zDdyLZAwRq2DhTo3Mbwz8iraB3Zc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)