UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '241M4H4GFF8ZKRkpk1Z0vOm9y3tpgLGyV2OZB4l0OIs='
WHERE
key_id = '1a0a749b9567f2ed7739bd66436447eab3c2ea16811aa62fd6c73b0f6a0b8897'
AND (
token = '241M4H4GFF8ZKRkpk1Z0vOm9y3tpgLGyV2OZB4l0OIs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)