UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'lKPXTlZWGJGp1O4cS6Zlkn4YlElA8YXy5l9abJI2XC4='
WHERE
key_id = 'f54f542be70b8d38d7296ba05ef1aa655858b500c134bf25d7356a0c752d1ac9'
AND (
token = 'lKPXTlZWGJGp1O4cS6Zlkn4YlElA8YXy5l9abJI2XC4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)