UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8OgQPDZLc17SD4Pqr8bHHhMuTv5drOYU8yvGpOGzNyk='
WHERE
key_id = 'aaec2eece761a45922678dcbb904a452f47ae2d2c4306affe0404da744ed7bcb'
AND (
token = '8OgQPDZLc17SD4Pqr8bHHhMuTv5drOYU8yvGpOGzNyk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)