UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'R4cYcRZL85aNjsNBTyWvvl8ypnITvhskSggjN3a1A+g='
WHERE
key_id = 'aa117474fe16a2e11acbd93be130b2a6d029bf1905908aecedc47c6b83c0ac2c'
AND (
token = 'R4cYcRZL85aNjsNBTyWvvl8ypnITvhskSggjN3a1A+g='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)