UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'NJN6d7yYc1o/vr6rAC9Iz03Zdfmhjx9T0UCW9kgs3iI='
WHERE
key_id = '4a41cac4513c918a3f6e50e5cd2b378324a886fd38f7d646c69f106bcafe25d6'
AND (
token = 'NJN6d7yYc1o/vr6rAC9Iz03Zdfmhjx9T0UCW9kgs3iI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)