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