UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'LKre8mT7TcpwgeYhdgU6V/tSB1U8HIeDIFFlekyFVOE='
WHERE
key_id = 'e975f85732348187b0e4dfc16513518c1a5043a834af7c22d05030859c9dab46'
AND (
token = 'LKre8mT7TcpwgeYhdgU6V/tSB1U8HIeDIFFlekyFVOE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)