UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pKGErpKodjavc9p7YciMBWUVmvAO419tPhfwKlX1DTI='
WHERE
key_id = 'e0b9a715c87016104f5bc831c1b2728e92fa135cd0542e2a4ec740898ffbd821'
AND (
token = 'pKGErpKodjavc9p7YciMBWUVmvAO419tPhfwKlX1DTI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)