UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'NFxx47oySQ0VaR7XvO03pvUQRv0ln25gc8jGjik8/V8='
WHERE
key_id = '07e91d25ff2bf225f3350aa55013b9dd1f52c009c82b5ef76f7d5b278f4f3aeb'
AND (
token = 'NFxx47oySQ0VaR7XvO03pvUQRv0ln25gc8jGjik8/V8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)