UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '3HkfrCT4wA1GIne2RcUtpUeo7d7ScYUWZS/BOGVdQIs='
WHERE
key_id = '7c455777e3a6b0da61eff6bcebd82382741c63cd7bcce8d4cd3a4eaea47ad2be'
AND (
token = '3HkfrCT4wA1GIne2RcUtpUeo7d7ScYUWZS/BOGVdQIs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)