UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'nK4rebfGK+/Vw0cJLPAK40iBuNvURtVcHshcVkIoGaA='
WHERE
key_id = '4c9756d2ce34cad318ae9d37ebfb6cc30abf0a9f6b987927a6ea87c91b011d50'
AND (
token = 'nK4rebfGK+/Vw0cJLPAK40iBuNvURtVcHshcVkIoGaA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)